UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tJ713o8TVYCvyO/7FWPS1x+VgvQya/LSSS4j1Ie6GF0=' 
WHERE 
  key_id = '4da0b6c40aedd67d70bf910e9fa385220a2ff6c9c61d354c6f69cd0f39bcbe79' 
  AND (
    token = 'tJ713o8TVYCvyO/7FWPS1x+VgvQya/LSSS4j1Ie6GF0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028