UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HAmlDybhTKxWLMJcQuxbvpR9ZgvlXSbjEyW4OZkwvhI='
WHERE
key_id = 'dfdb2fee67da5f9471a84a32aa17acc9a899ddeb5936ca2d62ac52505931880f'
AND (
token = 'HAmlDybhTKxWLMJcQuxbvpR9ZgvlXSbjEyW4OZkwvhI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)