UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'h4Bus3fyPISIKF5LSLgNbrtb+8hgtub0oUr1kAko9Mc=' 
WHERE 
  key_id = 'd11858eca31afcd8549aee14ab12ec6808e224a7da0e8ac986a9d77ef59803fc' 
  AND (
    token = 'h4Bus3fyPISIKF5LSLgNbrtb+8hgtub0oUr1kAko9Mc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044