UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'UFhVYlrAhfee8xFcUieJVbuM0U+2n0gFvOWOmEVWwCM=' 
WHERE 
  key_id = '88e9b39e9273edf6382d603f52b2cb09954c094eb1b6dee4740a014bb9d9069f' 
  AND (
    token = 'UFhVYlrAhfee8xFcUieJVbuM0U+2n0gFvOWOmEVWwCM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029