UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'lBbaO5QQGTSxlwTMMKxBsN+a6fT99y0s6cmJzf6xHzM=' 
WHERE 
  key_id = 'd32bf7f252583eb6b1c979b89ae81ef99b28b811ce63ec1e5338fff8a2ed0784' 
  AND (
    token = 'lBbaO5QQGTSxlwTMMKxBsN+a6fT99y0s6cmJzf6xHzM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042