UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VR9Z04exwJW+4W0fnycwJe2emvS0Zg1vWHNxnzbIM9w='
WHERE
key_id = 'a2ede856139b3de75e4c5623e408323bfa4e779051182c32db4c4c6eec2d7f4b'
AND (
token = 'VR9Z04exwJW+4W0fnycwJe2emvS0Zg1vWHNxnzbIM9w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)