UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '77A2BfVsmKCV8CqFWNlssbjdvy3ksdHVOM8Fb0pjnHE='
WHERE
key_id = 'acb40b2507824c39b9ffe74debd5e90c61857e3179a69fbf3c9805df7080dd1c'
AND (
token = '77A2BfVsmKCV8CqFWNlssbjdvy3ksdHVOM8Fb0pjnHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)