UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1vfK9VvMbvCWI8vNEjkSwUnlqVaiB/HQNbDEgXgLmWo='
WHERE
key_id = '4053e03abab18bc633ab7b33a64b12d2287a932306655b581a54956a8b3e93bb'
AND (
token = '1vfK9VvMbvCWI8vNEjkSwUnlqVaiB/HQNbDEgXgLmWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)