UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'AlNLUn4puZtaivJ6El7OqQN9iwrCmBH4/7s5hfRw1Fo=' 
WHERE 
  key_id = 'e40abdfe8a1464f8ea0eac9172814108b64eda67b2b26c8af90e842e0a78c7ef' 
  AND (
    token = 'AlNLUn4puZtaivJ6El7OqQN9iwrCmBH4/7s5hfRw1Fo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046