UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZNvqjtKPzGl/wTtsaKbfgjNVr31mB1lNWY0hjBy27T8='
WHERE
key_id = 'cfdaf8360fe2e30c425551ae99d46e9661a31fe8f8c754ee7b238de50ff64795'
AND (
token = 'ZNvqjtKPzGl/wTtsaKbfgjNVr31mB1lNWY0hjBy27T8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)