UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7sQcLnAxIILryUON6g9uMNWM4/n0HGvDifx+6Qu0voA=' 
WHERE 
  key_id = '76ddb2cd62a405bb22f3ee1343e87f4704ab5437d757d4a0e4cf76d49ef69d4e' 
  AND (
    token = '7sQcLnAxIILryUON6g9uMNWM4/n0HGvDifx+6Qu0voA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036