UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zBx26PooYNufiXM1V280RHCotp2wFZ9aozWCl+Ckouk='
WHERE
key_id = 'f848dba2e8cd71ed0c3579928b64c94eaef6c8dbb84852a7e38e70f87e684c33'
AND (
token = 'zBx26PooYNufiXM1V280RHCotp2wFZ9aozWCl+Ckouk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)