UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZmixLyqDuKzFSUrcCO82lIHJcImHJLu1veEWTYanv/w='
WHERE
key_id = '1fdb07c710147d1bf71383bec9d1cfb031737e93df9df3c1c7bc1cea8b04dcb8'
AND (
token = 'ZmixLyqDuKzFSUrcCO82lIHJcImHJLu1veEWTYanv/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)