UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EnX38+cLjrequrzTqsB6q5mklY19QI8FmKSzzvfGUUU='
WHERE
key_id = '822ac615b214308a0a4df2bf16449fec994a8b6bb82eaf0453b984391cf78b05'
AND (
token = 'EnX38+cLjrequrzTqsB6q5mklY19QI8FmKSzzvfGUUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)