UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B12eU2RWQf2bIuMfIOvXxNszmX5WK20PyJYJ+E8Ovks='
WHERE
key_id = '37dd6d6965d24581dfdaab322d63675ab5943b173605f20095cf4aec1785120e'
AND (
token = 'B12eU2RWQf2bIuMfIOvXxNszmX5WK20PyJYJ+E8Ovks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)