UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Sn8zXRDbpc1jrkE0vsbDPHSl+FcTEXFFFran6s69Cg='
WHERE
key_id = '9030f91ab5b946322fbee577858d89b02048f7107eb092374b5b3e9c8f46505a'
AND (
token = '7Sn8zXRDbpc1jrkE0vsbDPHSl+FcTEXFFFran6s69Cg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)