UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8AKlE7GmBJHsc29tlkDbrsK/ffA9g5qTwKA8COIqA58=' 
WHERE 
  key_id = '2b45f6916222bafe0157f0c79dc7d820ae376b22251290e8aeaf7a1291b64895' 
  AND (
    token = '8AKlE7GmBJHsc29tlkDbrsK/ffA9g5qTwKA8COIqA58=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025