UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5f6NogArAibLFD9hda2kCwAXdj1judBCFss1yoYe2yI='
WHERE
key_id = '91b45031eafe1451eac50048316733c18a338acbddd5b0ceb7545dfb63ae5639'
AND (
token = '5f6NogArAibLFD9hda2kCwAXdj1judBCFss1yoYe2yI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)