UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jI1/S1xUevbFT3FoTPViWIvNYdJacz3sRTQ0uo27e7s='
WHERE
key_id = '765a133831de46cfb4b9f112453b4d78e55b8342256b04cdee52ed82e5182027'
AND (
token = 'jI1/S1xUevbFT3FoTPViWIvNYdJacz3sRTQ0uo27e7s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)