UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r+IVAoZphYjiwZWGfOJIN1nK2e+akSf9jRV0EEE5mxA='
WHERE
key_id = '6d3479e76400b3cf9dcaa1d7443a421be69a5d8bacd33911d5950d0e1731406b'
AND (
token = 'r+IVAoZphYjiwZWGfOJIN1nK2e+akSf9jRV0EEE5mxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)