UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DqTHBmcNr2EG0TTSIEeJo4c9UL0OMwsJFe5hcs1TWv0='
WHERE
key_id = '2bb380f17e4e33ebbc62d35340f52c8d7520b7e5f6caa5ebe828e2b1c45d9dfe'
AND (
token = 'DqTHBmcNr2EG0TTSIEeJo4c9UL0OMwsJFe5hcs1TWv0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)