UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5HR9ionQyK5FtAEfJRaF72arcBDrno1uPAd4Gog3u1M='
WHERE
key_id = '3f8b46698d0df0eab00f065a588faf07d17253565be51c5a566f2233fd1897b9'
AND (
token = '5HR9ionQyK5FtAEfJRaF72arcBDrno1uPAd4Gog3u1M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)