UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'RP0Sed+5JHkC9HMSPbwr5hqJN24CyJ/wGMfjkmVqpUE=' 
WHERE 
  key_id = 'f9ed902c92e059fc065c19a33e31e06746fb34c99bf4f81c437a805a8cab10a2' 
  AND (
    token = 'RP0Sed+5JHkC9HMSPbwr5hqJN24CyJ/wGMfjkmVqpUE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034