UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'gS4DOs9I717tSbdT4YCri9G3gqeYL98CbW1eVis+1io=' 
WHERE 
  key_id = '58f0b7a705a0565436f8d938f42b60130e237c6b8df0407c72e7dad9068f220a' 
  AND (
    token = 'gS4DOs9I717tSbdT4YCri9G3gqeYL98CbW1eVis+1io=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031