UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'EO39a8u0isb32ClGQId8bK9LBcZTej7g+v+iljUCiOU=' 
WHERE 
  key_id = '9799d1ed26e7d43b4bf429365e44d4cabb80a8adb0a45a0a2b7fd7232ffc5c9e' 
  AND (
    token = 'EO39a8u0isb32ClGQId8bK9LBcZTej7g+v+iljUCiOU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032