UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FmnnuYh6jZrg2jt3Kzu5asTAJr9uczGvwToopf6ZEGw='
WHERE
key_id = 'c5b862852264c818c9aa4d9bee1d72f378a5ff1f604df03eb6f1ffa2b3a38201'
AND (
token = 'FmnnuYh6jZrg2jt3Kzu5asTAJr9uczGvwToopf6ZEGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)