UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ViIOUO3JGrFERgdJ7kUrc0qDABk7Vqx0nVcX6K7CKY='
WHERE
key_id = 'a914344d98a319a2cefbfdc3a579b89d24a66ef57d3e00ce0759bffee3244333'
AND (
token = '8ViIOUO3JGrFERgdJ7kUrc0qDABk7Vqx0nVcX6K7CKY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)