UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J9z5h0h01AOCY3VNEFMdZJYSQd9+Ha450i9sN7CnuHw='
WHERE
key_id = 'a7890e9951fbcf57c1b097eb4c5c641fc1e9e01d354ec4f46166c554d04fabb4'
AND (
token = 'J9z5h0h01AOCY3VNEFMdZJYSQd9+Ha450i9sN7CnuHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)