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

Query time 0.00024