UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MulPwUzBHiL3ARBRtm2KyKLn4bloaXKk4/EYpMdbBnE=' 
WHERE 
  key_id = '23667eba36f072431a80af03663391463096ad85a8ce88b2111a8e2e12c8eaf5' 
  AND (
    token = 'MulPwUzBHiL3ARBRtm2KyKLn4bloaXKk4/EYpMdbBnE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047