UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '56CNLb4L3LxitNe6bRGW7eUCh6Votz87+SmTmdIH2Go=' 
WHERE 
  key_id = '6df2e5c0eeafe2b2bed70670f5489fd7ac7320fbc3eff6d005ddfbe8dec92541' 
  AND (
    token = '56CNLb4L3LxitNe6bRGW7eUCh6Votz87+SmTmdIH2Go=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027