UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4ThbhFr5aMdY4fBKydN6ucDUm8eTtj6ompmaATwegas='
WHERE
key_id = 'd9974cf635c6e2f5cab26f6473701e575b52dccb5e73f5a7ad7dc767a0bab420'
AND (
token = '4ThbhFr5aMdY4fBKydN6ucDUm8eTtj6ompmaATwegas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)