UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Xm+KJzWdxWfJbytxB6v0xyWCOwSuOxsKCmvjXRzZnnc=' 
WHERE 
  key_id = '49e569328b40d6e73fad5cf2b535402a72c083fca798e37bb10021260c7251fa' 
  AND (
    token = 'Xm+KJzWdxWfJbytxB6v0xyWCOwSuOxsKCmvjXRzZnnc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031