UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MfEJUxrouAtkQso7g9mGD02wQ3j34vG+Tj4QUMf+Mps=' 
WHERE 
  key_id = '26bafd499401eece53e35adc1f3d8152dd993c5596a8b287c0b73f66ab5b2ebf' 
  AND (
    token = 'MfEJUxrouAtkQso7g9mGD02wQ3j34vG+Tj4QUMf+Mps=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021