UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R65ZNYhPOclq6jGC8ssSAQZ9/Zua/Q4FkCbji91Hej4='
WHERE
key_id = 'c5804390100ca58a2a8bdd5658c8b462d04ac2525c1b63360c51d7bfac590a7f'
AND (
token = 'R65ZNYhPOclq6jGC8ssSAQZ9/Zua/Q4FkCbji91Hej4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)