UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'j8WX9Qj0F1YIu8GJyGHJaYGPQ2HQCvbkbyib/nJq0vY=' 
WHERE 
  key_id = 'd477a3cb0d5174ed7f555e592a6d46b95e1e7277f0dd544b2aa44a4eaed12e40' 
  AND (
    token = 'j8WX9Qj0F1YIu8GJyGHJaYGPQ2HQCvbkbyib/nJq0vY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022