UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8+ie/qHrAHMsL600NPN8s7J5dG/XNI6vyeLya/wRePc=' 
WHERE 
  key_id = 'c771641ef7724e11643c6505d5fd41bba9cf3ef97f8d4725e4aed13b5a97ddb4' 
  AND (
    token = '8+ie/qHrAHMsL600NPN8s7J5dG/XNI6vyeLya/wRePc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032