UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'sExUJP55jR0Vg3jIVaLFvFh1xjdLMKjH7HApVCRkAME=' 
WHERE 
  key_id = 'f7ac07066494792ced979948e1143f02ce6b3b2ee865d6b2e11d3a09bab2954e' 
  AND (
    token = 'sExUJP55jR0Vg3jIVaLFvFh1xjdLMKjH7HApVCRkAME=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00017