UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zW6ZiZC4Z/Ljz/k/OEIpar+3P4qg/P6VuxpvFN0vDYs='
WHERE
key_id = 'a267b21a4c434fe76398a2c799d8a457dc97d9971eecb651f1fc32bedf4be749'
AND (
token = 'zW6ZiZC4Z/Ljz/k/OEIpar+3P4qg/P6VuxpvFN0vDYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)