UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'gTC1+WRX5+uD7IT6/bIMvxwhSIwrUU7KQWIDwPXbEAU=' 
WHERE 
  key_id = '342f1f2c597af5af8f0c7228d6fb39a1f57270c6bbfe057a732da9c19ccde21c' 
  AND (
    token = 'gTC1+WRX5+uD7IT6/bIMvxwhSIwrUU7KQWIDwPXbEAU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041