UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nQA2u+9jSa0oKn4MNZZwvT67yD6NeUgCRqJwKjBMFo8='
WHERE
key_id = '2c4fc335f89e18bd2126994c05ef0475a35f47a6469182c3d5f5f78e923897d2'
AND (
token = 'nQA2u+9jSa0oKn4MNZZwvT67yD6NeUgCRqJwKjBMFo8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)