UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'nNe2T9y4aD4LEObMSLxI0PivRpLjyTTeaW9vzshvf+U=' 
WHERE 
  key_id = '639fd26c9d7676df9c3dc3079c9b6dc03f1aed12f98c48aaf8e5ef53ebad8b50' 
  AND (
    token = 'nNe2T9y4aD4LEObMSLxI0PivRpLjyTTeaW9vzshvf+U=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039