UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x+Kq/MvaJ6AXIIeGkkuth9U8xuPFKNWWJXznkTUR/ZI='
WHERE
key_id = 'cd1dc4ad8084c88228a949f26dae5c1e1775c5f8143acf7b4103c0394e4f194f'
AND (
token = 'x+Kq/MvaJ6AXIIeGkkuth9U8xuPFKNWWJXznkTUR/ZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)