UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ACvvGI4vX4BJ117939p4Up4NZSmz7gpHysf7g4uu7pw=' 
WHERE 
  key_id = '1c1c721bc8b8a4cf102768b3f41b5feb2a9f634399e5209dc95d72572658a6e0' 
  AND (
    token = 'ACvvGI4vX4BJ117939p4Up4NZSmz7gpHysf7g4uu7pw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020